package com.eco.fanliapp.dao;

import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.eco.fanliapp.entity.SyChannelGoods;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * <p>
 * 渠道商品对照表 Mapper 接口
 * </p>
 *
 * @author jobob
 * @since 2019-11-04
 */
public interface SyChannelGoodsMapper extends BaseMapper<SyChannelGoods> {

    List<SyChannelGoods> selectSyChannelGoods();

    int delectSyChannelGoods(@Param("tableId") Long tableId);

    SyChannelGoods getSyChannelGoodsByItemId(@Param("itemId") Long itemId);

    SyChannelGoods selectByChannelAndItemId(@Param("itemId") Long itemId, @Param("channelId") Long channelId);

    SyChannelGoods selectByItemId(@Param("itemId") Long itemId);

    int updateSyChannelGoods(SyChannelGoods syChannelGoods);

    List<SyChannelGoods> findChannelGoodsCommission();

    SyChannelGoods selectChannelGoodsById(@Param("itemId") Long itemId);

    SyChannelGoods selectByItemIdNew(@Param("itemId") Long itemId);
}
